Overview
What is Oracle Enterprise Manager?
Oracle’s Enterprise Manager is an on-premises monitoring and management tool. The console is designed primarily to manage other Oracle products, it but can integrate to manage non-Oracle components as well.
Great management solution for large enterprises
Oracle Enterprise Manager is definitely a one-stop solution
OEM: Great for monitoring and managing all layers of enterprise systems
Oracle Enterprise Manager - a valuable product for maintaining thousands of databases
OEM: Best Tool for Oracle Databases
The best tool for admins on Oracle Environment.
OEM is the best!!!
OEM great for Oracle dbs and current hardware; older vendors, not so much
OEM: A life saver for Oracle professionals
Good support on Oracle Enterprise Manager
Oracle Enterprise Manager Review
Oracle Enterprise Manager - A Comprehensive Enterprise-Wide Database System Management Tool
OEM rocks!
Oracle Enterprise Manager - a perfect tool for monitoring databases and for performance tuning.
1. To monitor production databases for alerts against set thresholds.
2. To diagnose …
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Automated alerts and notifications (14)8.585%
- Multiple Server Monitoring (14)8.282%
- Performance data reports (14)7.979%
- Administrator access control (14)3.636%
Pricing
What is Oracle Enterprise Manager?
Oracle’s Enterprise Manager is an on-premises monitoring and management tool. The console is designed primarily to manage other Oracle products, it but can integrate to manage non-Oracle components as well.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
20 people also want pricing
Alternatives Pricing
What is Atera?
Atera is a platform that enables IT professionals to gain access, visibility, and control over all their networks and devices from anywhere. Users can manage their IT operation from patch management, IT automations, advanced reporting, alerts, helpdesk, ticketing, and it features dozens of…
What is SolarWinds Pingdom?
SolarWinds Pingdom is a website uptime monitoring and alert tool, with additional reporting and Real User Monitoring capabilities. Pingdom is part of SolarWinds’s DevOps package, enabling full-stack monitoring as a service.
Product Demos
Oracle Enterprise Manager 12c: Managing Exalogic Elastic Cloud and WebLogic
Advanced Installation of Oracle Enterprise Manager 13.2
Backup Oracle Database using Oracle Enterprise Manager
Features
Monitoring Tasks
Various types of monitoring
- 7.9Remote monitoring(13) Ratings
Monitoring of network operational activities through the use of remote devices known as monitors or probes
- 9Network device monitoring(9) Ratings
Monitor the real-time performance and health of devices on your network
- 8.2Multiple Server Monitoring(14) Ratings
Server Monitoring is a process to monitor server's system resources like CPU Usage, Memory Consumption, I/O etc.
- 8.2Multi-device monitoring(11) Ratings
Network device monitoring in real time for any devices on your network
- 8.5Automated alerts and notifications(14) Ratings
System generates alerts and notifications to provide timely intervention if required
Management Tasks
Various tasks required to keep systems running smoothly
- 7.8Patch Management(12) Ratings
Patch management involves acquiring, testing, and installing multiple patches (code changes) to an administered computer system.
- 9Service configuration management(11) Ratings
Service configuration management looks at all stages of the service lifecycle in order to provide information about an organization’s performance
- 6.5Software and hardware inventory(13) Ratings
Management of the physical and software from acquisition through disposal.
- 8.8Policy-based automation(11) Ratings
Policy-based management is an administrative approach used to simplify the system management by drafting rules to deal with common situations
Reporting
Report generation to help with system monitoring tasks
- 7.9Performance data reports(14) Ratings
Standardized reports containing system monitoring data and metrics
- 4.2Customizable reporting(12) Ratings
Administrators can use reporting engine to build custom reports
- 8.2Data visualization(13) Ratings
Ability to produce visualizations to simplify understanding of data
- 8Risk analysis(10) Ratings
Indicators of risk factors that need to be addressed
Security
Management of security aspects of system monitoring
- 3.4Data backup and recovery(12) Ratings
Backup and recovery of lost data
- 5Antivirus and malware management(5) Ratings
Detection of security risks like malware and viruses
- 3.6Administrator access control(14) Ratings
Management and restriction of user access to specific system assets
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Enterprise Manager?
For more information visit https://www.oracle.com/enterprise-manager/technologies/
Oracle Enterprise Manager Video
Oracle Enterprise Manager Competitors
Oracle Enterprise Manager Technical Details
Operating Systems | Unspecified |
---|---|
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(109)Attribute Ratings
Reviews
(1-10 of 10)Oracle Enterprise Manager - a valuable product for maintaining thousands of databases
It's great for monitoring multiple systems and has a wide variety of pre-built metrics. It can be used for deploying scripts to our entire system. It's easy to use and critical for technical users as well as non-technical users.
- Displays visuals of database health
- Shows internal data structures (tablespaces, objects, users, etc)
- Monitors database health
- Can be used for deployment of PL/SQL and other scripts
- It can be very buggy, sometimes preventing jobs from running
- It can miss errors and lead to database outages
- Can be slow during updating of internal settings
If you have small databases that are lightweight and are low-maintenance, OEM may not be useful. For larger companies, it can be very useful.
OEM: Best Tool for Oracle Databases
- Dashboard: Options to choose Home Page. Best for DBAs, best for new users and etc. I selected "best for DBAs" as my Home Page. It gives you the status (up or down) of all the databases registered. If you click each database a nice diagram shows up. On the left, you will see Load and Capacity, Incidents and Compliance, Recommendations for findings and SQL tuning, Last Backup and if there are any Jobs running.
- Performance Home: Overview diagram of host average runnable processes, average active sessions, throughput, I/O, parallel execution, services. It also provides additional links to top consumers, instance locks, duplicate SQL, instance activities and SQL response time.
- Top activity is another nice feature: details for 5 minute intervals. It further provides top SQL and top session. This is my go-to page for database performance tuning. You click the top SQL to get details on the "troubled" query, statistics, activities, plan and tuning history.
- SQL tuning advisor is another nice feature: you can schedule a job to run the SQL tuning advisor or run it immediately.
- AWR Report: when we start having DB performance issues, we run AWR a pare of snapshot reports and then compare them with a baseline report to nail down what has caused performance degradation.
- Security: users, roles, profiles, auditing settings, data masking, and subsetting, data redaction, transparent data encryption, data vault, label security, virtual private database, and enterprise user security.
- Scheduling jobs: we have 70 jobs running every day - backup, space, monitoring and sending alerts to email.
- We also use OEM to monitor SQL Server. However, OEM only provided limited features for SQL Server. It would be nice if we can schedule backup jobs for SQL Server in OEM.
- The ability to run SQL queries. You can't run queries in OEM. I have to go to SQL Developer or SQL PLUS to run. queries.
OEM is the best!!!
- Allows you to manage multiple databases in one GUI.
- Allows you to run jobs on multiple databases at one time.
- Helps you maximize Oracle Database tuning and SQL tuning.
- Also, helps manage dataguard within multiple databases.
- Notification emails. Notifications are sending out emails for failed jobs 7 days later of the same error of the same job.
- Being able to have redundancy for Oracle Enterprise Manager. This is way too complicated to get set up and has too many problems getting it set up. The documentation is not very good. Just making it more user-friendly and easier to install.
- Starting OMS takes to long. Depending on the machine it can take up to 10 minutes for OMS to start up.
- Provides a graphical interface to Oracle Database metrics (therefore one does not need to manually execute queries on a database to find information).
- Provides a graphical interface to hardware metrics (like cpu, memory, network, i/o utilization). This is very important as it allow non system administrators to view and understand information regarding the hardware that an Oracle Database is running on.
- Has built in features to dynamically build databases, implement RAC (cluster), implement Data Guard, and many other optional add on features to Oracle databases.
- Has the ability to generate performance data (and other) reports that can be also be easily delivered within the organization, all through the OEM interface.
- Information can sometimes be hard to find within OEM. There are so many different attributes that it can be difficult to find the exact area where key information can be found.
- If OEM is running slowly, it can be hard to diagnose where the problem exists.
- If OEM is having a performance issues and disconnects, all data is lost. This can be particularly frustrating if reports are being generated or a data guard configuration is being implemented.
- Configuring credential setup can be very time consuming and confusing. There should be a central user that has base level OEM access for any database added to the OEM OMS repository.
- Manually inputting credentials is very onerous.
- As a graphical interface, not all query information is provided and therefore it can be difficult to hone a dba skill set. Since not all queries are shown, if OEM is unavailable, one will not know how to retrieve the same information directly from the database.
OEM is not well suited for older hardware vendors like AIX, HP-UX, DEC/Digital, Microsoft (sql server). This is a big negative as most large companies have a heterogeneous environment with many different vendor hardware and (database) software products.
Good support on Oracle Enterprise Manager
Currently, I am using OEM tools 13c, and I previously used the 11g and 12c version of Oracle Enterprise Manager.
- It is used to provide more than others as compared to price.
- Basically, it is used to check our database connection.
- Oracle provides quick support on any issue.
- It manages various activities, and handling is easy to use for good GUI functionality.
- Some features are complicated for new users to understand on my first attempt.
- There is some time connection loss issue.
- They need to provide better features in some aspects.
Oracle Enterprise Manager - A Comprehensive Enterprise-Wide Database System Management Tool
- It manages all relevant targets (hosts, Oracle databases, and listeners) in one place
- We can use it to quickly drill down an issue to its detail
- In addition to monitoring and performance tuning, it can be used to present information effectively
- It relies on a monitoring agent to be installed on monitored target hosts, and that dependency can be problematic at times
- The performance of Oracle Enterprise Manager itself can be slow
OEM rocks!
- OEM is fantastic at monitoring databases and servers. It is a single place to check the enterprise-wide database, listener, agent, and server status. You can set thresholds on many metrics including space at the operating system level and the database level.
- OEM can easily push agents to remote servers.
- Once an agent is deployed to a server, it can easily be configured to monitor the server, databases, listener, and agent with various thresholds on many metrics. Alerts can be viewed on the OEM Console or via email.
- OEM can be used to administer databases. Any function that can be done in an SQLplus command line can also be done in OEM. A few such tasks are tablespace management, user management, table/index/object management, etc.
- OEM can be used to implement Dataguard Standby databases.
- OEM can be used to monitor backups in real time.
- OEM can be used to monitor SQL real time. The Diagnostic and Tuning Packs allow you to create SQL Profiles for slow SQL that can increase run times by 1000s of percents.
- There can be some bugs in OEM. Usually there is a workaround, but sometimes you might need to install a patch.
Enterprise Manager-Your database Watchdog
- Creates visuals and graphic indicators for monitoring critical database operations and states.
- Easily identify problematic connections, performance issues, blocking sessions, and identify sql code or scripts that are degrading database performance.
- Easily display AWR reporting or ASH analytic's with a few clicks.
- Easily set up jobs with Oracle scheduler, which you would have to otherwise script directly on the database.
- Connections to targets can become lost or dropped, resulting in the application not doing anything when clicking on a link, with no type of indication of what the issues is.
- Log outs from the console sometime do not complete, and users remain logged in, even after closing the browser session.
- The timeout function in the console has always been problematic, causing me to have to change the time out setting in the config file, whereas the option to disable the time outs on the console when the option comes up does not work. Selecting the option to disable timeouts still causes idle sessions to timeout.
OEM Oracle's swiss army knife
- Gives a big picture view your Oracle infrastructure, and plug-ins for SQL Server, IIS if needed.
- Manages jobs in each instance using dbms_scheduler package.
- Integrates with Oracle support for patch download, applies patches.
- Manages space in tablespaces, data files. Alerts set to your comfort level for warning critical thresholds.
- Interface clunky at times. Some space management is faster in SQL Developer DBA tool. Their free tool works well.
- Setup of default page gets lost at times. Bug?
- Managing a script run across databases. The default is backwards. SYSDBA should be the default. Not normal.
Oracle Enterprise Manager - Robust Environment Management
- Oracle Enterprise Manager lets you control access to an environment for various users across your organization. You can define users, groups, and their credentials. You can define application roles and application policies. This is an excellent functionality which is robust in nature.
- Oracle Enterprise Manager improves the deployment process on multiple folds using single clicks. You select an RPD, deploy the same and restart your services within a few simple clicks. No need to reach the back end and fall into a tedious loop.
- Oracle Enterprise Manager notifies the user of any component being down in a graphical manner and points to an exact component being down. This helps in the debugging process.
- Simple functionality like one to many mapping of users to groups could be done which would be a useful feature to a DBA/Admin while adding new users.
- Recovery of logs needs to be more user-friendly. Whenever we face a system downtime issue, exact logs are a little difficult to find. It can get really tedious to point out the problem when looking at generic logs.
- No cross application navigation is present to other OBIEE products. There needs to be a functionality which can navigate a user from Oracle Enterprise Manager to Oracle BI Analytics.
- In the RPD Deployment process, there should be a functionality to deploy previously deployed RPDs. In this way, the administrator can keep a track of all previously used RPDs and it's deployments.